restore controlfile from 'C:\back\ORCL_2_20090414_FULL.BAK';
set newname for datafile 4 to 'E:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF';
cmd2：

set oracle_sid=orcl
host "md c:\back";
把收到的文件夹orcl放到e:\oracle\product\10.2.0\admin
cmd2:
shutdown immediate;
找到跟踪文件：
select name from v$database;
cmd3:
select name from v$archived_log;
}
select name from v$datafile;
run
select member from v$logfile; 拷贝
set oracle_sid=orcl
{
GROUP 2 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG' SIZE 50M,
rman target sys/abc
查看跟踪文件位置：
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF',
创建要恢复oracle的目录
alter database backup controlfile to trace;
set oracle_sid=orcl
shutdown immediate;
GROUP 3 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG' SIZE 50M
机器B:
c:\back
rman target sys/abc
MAXINSTANCES 8
sqlplus / as sysdba
MAXLOGFILES 16
set oracle_sid=orcl
startup mount;
alter database mount;
set newname for datafile 5 to 'E:\oracle\product\10.2.0\oradata\orcl\XM';
startup mount;
set newname for datafile 2 to 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF';
CHARACTER SET ZHS16GBK
cmd3:
}
DATAFILE
d:\替换为e:\
-- STANDBY LOGFILE
select file#,name from v$datafile;
set newname for datafile 3 to 'E:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF';
打开控制文件跟踪：
shutdown immediate;
switch datafile all;
GROUP 1 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG' SIZE 50M,
archive log list;
set newname for datafile 1 to 'E:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF';
d:\改为 e:\
查询日志模式：
e:\oracle\product\10.2.0\admin\orcl\pfile中的参数文件到自己真实数据库db_1\database文件夹中，并改名为initorcl.ora
cmd：
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF',
startup nomount;
alter system archive log current;
e:\oracle\product\10.2.0\oradata\orcl
把里面的路径改为真实oracle数据库的位置
MAXLOGHISTORY 292
select instance_name from v$instance;
format 'c:\back\%d_%s_%T_full.bak';
CREATE CONTROLFILE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
等到提示ctrl+c
select name from v$database;
backup database;
重做控制文件：把里面的路径改为正确路径：
执行生成控制文件的语句;执行钱必须先删除.ctl的文件
MAXDATAFILES 100
alter database open resetlogs;
select name from v$database;
show parameter user_dump_dest
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\XM'
LOGFILE
startup nomount;
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF',
restore database;
alter database backup controlfile to trace;
oracle orcl
机器A:
传送以下文件到机器B:
打开initorcl.ora
d:\oracle\product\10.2.0\admin\orcl
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF',
alter database open;
cmd2:
e:\oracle\product\10.2.0\falsh_recovery_area
cmd1：
run{
e:\oracle\product\10.2.0\admin
把日志改为归档模式：
alter database archivelog;
MAXLOGMEMBERS 3